XQuery in Relational Database Systems
نویسنده
چکیده
Relational database systems (and the related standards body ANSI/INCITS H2) are busy adding XML support. One of the main components of such XML extensions will be support for the upcoming XML query language XQuery. The presentation will outline how XQuery and XML conceptually fit into a relational database environment. It will cover the organization of the XML in the database, how to type it using W3C XML Schema, how to query it both in conjunction with SQL and using top-level XQuery. It will present the concepts, talk about new developments in the ISO/ANSI SQL/XML standards and present some demos of XQuery in the upcoming Microsoft® SQL Server 2005.
منابع مشابه
Pathfinder: XQuery compilation techniques for relational database targets
Relational database systems are highly efficient hosts to table-shaped data. It is all the more interesting to see how a careful inspection of both, the XML tree structure as well as the W3C XQuery language definition, can turn relational databases into fast and scalable XML processors. This work shows how the deliberate choice of a relational tree encoding makes the XML data model—ordered, unr...
متن کاملPathfinder: A Relational Query Optimizer Explores XQuery Terrain
Relational encodings of the static aspects of the XQuery data model, i.e., tabular representations for XML documents and ordered sequences of items, are widely used today. Since 2002, the Pathfinder andMonetDB/XQuery companion projects [BGvK06] pursue the primary goal to also embrace the complete dynamic semantics of XQuery (expression evaluation and runtime aspects) with the help of relational...
متن کاملIntegration of SQL and XQuery
F. Özcan D. Chamberlin K. Kulkarni J.-E. Michels Relational database systems have dominated the database industry for a quarter century. However, the advent of the Web has led to requirements for storage of new kinds of information in which the order of information is important and data structure can vary over time and from one document to another. These evolving requirements have given rise to...
متن کاملXML programming with SQL/XML and XQuery
Most business data are stored in relational database systems, and SQL (Structured Query Language) is used for data retrieval and manipulation. With XML (Extensible Markup Language) rapidly becoming the de facto standard for retrieving and exchanging data, new functionality is expected from traditional databases. Existing SQL applications will evolve to retrieve relational data as XML data using...
متن کاملPathfinder: Relational XQuery Over Multi-Gigabyte XML Inputs In Interactive Time
Using a relational DBMS as back-end engine for an XQuery processing system leverages relational query optimization and scalable query processing strategies provided by mature DBMS engines in the XML domain. Though a lot of theoretical work has been done in this area and various solutions have been proposed, no complete systems have been made available so far to give the practical evidence that ...
متن کامل